Updatable Property (Remote Data)

Returns a Boolean value that indicates whether changes can be made to a remote data object.

Syntax

object.Updatable

The object placeholder represents an object expression that evaluates to an object in the Applies To list.

Return Values

The Updatable property return values are:

Remarks

If the Updatable property setting is True, the specified:

• rdoConnection object refers to an updatable data source.
  
  
• rdoQuery object refers to an updatable result set.
  
  
• rdoResultset contains updatable rows.
  
  
• rdoTable object refers to a table whose data can be changed through use of a query.
  
  
• rdoColumn object refers to data that can be changed. Only rdoColumn objects which are part of an rdoResultset object can be changed.

You can use the Updatable property with all types of rdoResultset objects.

Many types of rdoResultset objects can contain columns that can't be updated. For example, you can create a forward-only rdoResultset that is derived from nonupdatable sources or that contains computed or derived columns.

If the object contains only nonupdatable columns, the value of the Updatable property is False. When one or more columns are updatable, the property's value is True. You can edit only the updatable columns. A trappable error occurs if you try to assign a new value to a nonupdatable column.

Because an updatable object can contain columns that cannot be updated, check the Updatable property of each rdoColumn before editing a row in the rdoResultset.

Even when a cursor cannot be updated, it might still be possible to update the data through use of an action query. In many cases, database tables are protected and not updatable by design — as they are protected from direct access by the system administrator and the remote system's permission scheme. If this is the case, check with your system administrator for the availability of stored procedures or special login accounts that permit you to perform your changes.